--------------------------------------------------------------------------------
      name:  <unnamed>
       log:  D:\Dropbox\Work\Research\CreditCardABSRewrite\Draft\ReplicationFile
> s\Tab_12\Table_12_Log.log
  log type:  text
 opened on:   1 Jan 2022, 16:12:07

. 
. 
. import delimited "Data_Table_12.csv"
(encoding automatically selected: ISO-8859-2)
(9 vars, 8,166 obs)

. 
. * generate indicators for subperiods
. generate pre=1 if year<2007
(4,540 missing values generated)

. generate cri=1 if year>2006 & year<2010
(5,638 missing values generated)

. generate post=1 if year>2009 & year<2021
(6,154 missing values generated)

. 
. * Table 10
. 
. *****************
. * A Tranche
. * All
. regress riskprem_a chargeoff chargeofftrend i.year, vce(cluster year)

Linear regression                               Number of obs     =      8,166
                                                F(1, 19)          =          .
                                                Prob > F          =          .
                                                R-squared         =     0.5385
                                                Root MSE          =     .84685

                                   (Std. err. adjusted for 20 clusters in year)
-------------------------------------------------------------------------------
              |               Robust
   riskprem_a | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
--------------+----------------------------------------------------------------
    chargeoff |   .0313675   .0682106     0.46   0.651    -.1113989    .1741339
chargeofftr~d |   .0881009   .1697346     0.52   0.610    -.2671576    .4433595
              |
         year |
        2001  |    .035828   .0219059     1.64   0.118    -.0100216    .0816775
        2002  |  -.0565392   .0173919    -3.25   0.004    -.0929409   -.0201375
        2003  |  -.1292882   .0060883   -21.24   0.000    -.1420313   -.1165452
        2004  |  -.0595254    .030789    -1.93   0.068    -.1239675    .0049167
        2005  |  -.1981283   .0576124    -3.44   0.003    -.3187125   -.0775442
        2006  |  -.0148197   .1890665    -0.08   0.938    -.4105405     .380901
        2007  |    .175467   .1706712     1.03   0.317    -.1817519    .5326859
        2008  |   2.401577   .0701144    34.25   0.000     2.254826    2.548328
        2009  |   1.863123   .2087477     8.93   0.000     1.426209    2.300037
        2010  |  -.0104534   .1709114    -0.06   0.952    -.3681751    .3472683
        2011  |   .0331482   .0742769     0.45   0.660    -.1223151    .1886115
        2012  |  -.0191625   .2181143    -0.09   0.931    -.4756809     .437356
        2013  |   .0560645   .2401083     0.23   0.818    -.4464879    .5586169
        2014  |   .0890194   .2535489     0.35   0.729    -.4416646    .6197034
        2015  |   .1693619   .2656989     0.64   0.531    -.3867523    .7254762
        2017  |   .0328023   .2089913     0.16   0.877    -.4046216    .4702262
        2018  |   .0549082   .2349844     0.23   0.818    -.4369199    .5467362
        2019  |  -.0314735   .1810099    -0.17   0.864    -.4103317    .3473846
        2020  |  -.1831175   .1935367    -0.95   0.356    -.5881946    .2219595
              |
        _cons |   .2642123   .4243954     0.62   0.541    -.6240575    1.152482
-------------------------------------------------------------------------------

. outreg2 using Tab12_A, stats(coef tstat) noaster adjr2 nocons title("A Tranche
> ") ctitle("All") drop(i.year riskprem*) bdec(4) bfmt(f) tdec(2) tfmt(f) rdec(3
> ) rfmt(f) word replace
Tab12_A.rtf
dir : seeout

. * 2000-2006
. regress riskprem_a chargeoff chargeofftrend i.year if pre==1, vce(cluster year
> )

Linear regression                               Number of obs     =      3,626
                                                F(1, 6)           =          .
                                                Prob > F          =          .
                                                R-squared         =     0.0699
                                                Root MSE          =      .3943

                                    (Std. err. adjusted for 7 clusters in year)
-------------------------------------------------------------------------------
              |               Robust
   riskprem_a | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
--------------+----------------------------------------------------------------
    chargeoff |  -.0446172   .0304219    -1.47   0.193    -.1190568    .0298224
chargeofftr~d |  -.0712124   .0158636    -4.49   0.004    -.1100293   -.0323955
              |
         year |
        2001  |   .0762014    .009263     8.23   0.000     .0535356    .0988671
        2002  |  -.0284238   .0080199    -3.54   0.012    -.0480476   -.0087999
        2003  |  -.1322241    .001168  -113.20   0.000    -.1350821   -.1293661
        2004  |  -.1034393   .0142616    -7.25   0.000    -.1383361   -.0685425
        2005  |  -.2448659   .0239137   -10.24   0.000    -.3033806   -.1863512
        2006  |  -.2448797   .0857752    -2.85   0.029    -.4547641   -.0349953
              |
        _cons |   .7311632   .1887941     3.87   0.008     .2692006    1.193126
-------------------------------------------------------------------------------

. outreg2 using Tab12_A, stats(coef tstat) noaster adjr2 nocons title("A Tranche
> ") ctitle("2000-2006") drop(i.year riskprem*) bdec(4) bfmt(f) tdec(2) tfmt(f) 
> rdec(3) rfmt(f) word 
Tab12_A.rtf
dir : seeout

. 
. * 2007-2009
. regress riskprem_a chargeoff chargeofftrend i.year if cri==1, vce(cluster year
> )

Linear regression                               Number of obs     =      2,528
                                                F(1, 2)           =          .
                                                Prob > F          =          .
                                                R-squared         =     0.3947
                                                Root MSE          =     1.3693

                                    (Std. err. adjusted for 3 clusters in year)
-------------------------------------------------------------------------------
              |               Robust
   riskprem_a | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
--------------+----------------------------------------------------------------
    chargeoff |    .072821   .3280861     0.22   0.845    -1.338819    1.484461
chargeofftr~d |   .9517385   .1971165     4.83   0.040     .1036149    1.799862
              |
         year |
        2008  |   2.003993      .5732     3.50   0.073    -.4622874    4.470274
        2009  |    1.35334   1.828804     0.74   0.536    -6.515369     9.22205
              |
        _cons |   .2199472   1.235518     0.18   0.875    -5.096059    5.535953
-------------------------------------------------------------------------------

. outreg2 using Tab12_A, stats(coef tstat) noaster adjr2 nocons title("A Tranche
> ") ctitle("2007-2009") drop(i.year riskprem*) bdec(4) bfmt(f) tdec(2) tfmt(f) 
> rdec(3) rfmt(f) word
Tab12_A.rtf
dir : seeout

. 
. * 2010-2020
. regress riskprem_a chargeoff chargeofftrend i.year if post==1, vce(cluster yea
> r)

Linear regression                               Number of obs     =      2,012
                                                F(1, 9)           =          .
                                                Prob > F          =          .
                                                R-squared         =     0.1133
                                                Root MSE          =     .24892

                                   (Std. err. adjusted for 10 clusters in year)
-------------------------------------------------------------------------------
              |               Robust
   riskprem_a | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
--------------+----------------------------------------------------------------
    chargeoff |   .0279617   .0084423     3.31   0.009     .0088638    .0470596
chargeofftr~d |  -.0138351   .0089506    -1.55   0.157    -.0340828    .0064125
              |
         year |
        2011  |   .0264504   .0295212     0.90   0.394    -.0403312     .093232
        2012  |  -.0130837   .0476894    -0.27   0.790    -.1209646    .0947971
        2013  |   .0617492   .0503976     1.23   0.252     -.052258    .1757564
        2014  |   .0677911   .0522318     1.30   0.227    -.0503655    .1859476
        2015  |   .1789143   .0534515     3.35   0.009     .0579986    .2998299
        2017  |   .0433928   .0464743     0.93   0.375    -.0617395     .148525
        2018  |   .0584708   .0498071     1.17   0.271    -.0542007    .1711423
        2019  |  -.0153772   .0428989    -0.36   0.728    -.1124212    .0816667
        2020  |  -.1268956    .004143   -30.63   0.000    -.1362676   -.1175236
              |
        _cons |   .2659969   .0731695     3.64   0.005      .100476    .4315178
-------------------------------------------------------------------------------

. outreg2 using Tab12_A, stats(coef tstat) noaster adjr2 nocons title("A Tranche
> ") ctitle("2010-2020") drop(i.year riskprem*) bdec(4) bfmt(f) tdec(2) tfmt(f) 
> rdec(3) rfmt(f) word
Tab12_A.rtf
dir : seeout

. 
. 
. *******************
. * B Tranche
. * All
. regress riskprem_b chargeoff chargeofftrend i.year, vce(cluster year)

Linear regression                               Number of obs     =      8,166
                                                F(1, 19)          =          .
                                                Prob > F          =          .
                                                R-squared         =     0.5564
                                                Root MSE          =     2.3394

                                   (Std. err. adjusted for 20 clusters in year)
-------------------------------------------------------------------------------
              |               Robust
   riskprem_b | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
--------------+----------------------------------------------------------------
    chargeoff |  -.0633399   .2075387    -0.31   0.764    -.4977234    .3710435
chargeofftr~d |   .6877859   .7349877     0.94   0.361    -.8505612    2.226133
              |
         year |
        2001  |   .0623652    .052696     1.18   0.251    -.0479288    .1726591
        2002  |   .0437749   .0419809     1.04   0.310    -.0440922    .1316419
        2003  |   .0493359   .0263848     1.87   0.077    -.0058881    .1045598
        2004  |   .0418599   .0809873     0.52   0.611    -.1276484    .2113682
        2005  |  -.2765313   .1968328    -1.40   0.176     -.688507    .1354445
        2006  |  -.2307825   .5496095    -0.42   0.679    -1.381128    .9195635
        2007  |   .0490796   .5493551     0.09   0.930    -1.100734    1.198893
        2008  |   5.106963   .2897055    17.63   0.000     4.500603    5.713324
        2009  |   7.870122    .572097    13.76   0.000     6.672709    9.067534
        2010  |   .8907642   .5640065     1.58   0.131     -.289715    2.071243
        2011  |   .7227781   .1783529     4.05   0.001     .3494813    1.096075
        2012  |   .6470268   .6640577     0.97   0.342    -.7428619    2.036915
        2013  |    .211309   .7330426     0.29   0.776    -1.322967    1.745585
        2014  |   .1030547   .6994958     0.15   0.884    -1.361007    1.567116
        2015  |   -.054775   .8260467    -0.07   0.948    -1.783711    1.674161
        2017  |  -.0968057   .6482286    -0.15   0.883    -1.453564    1.259952
        2018  |  -.1073488   .7104865    -0.15   0.881    -1.594414    1.379717
        2019  |  -.1488617   .5752367    -0.26   0.799    -1.352846    1.055123
        2020  |   .0518662   .5074335     0.10   0.920    -1.010204    1.113937
              |
        _cons |   .9605206   1.298841     0.74   0.469    -1.757985    3.679027
-------------------------------------------------------------------------------

. outreg2 using Tab12_B, stats(coef tstat) noaster adjr2 nocons title("B Tranche
> ") ctitle("All") drop(i.year riskprem*) bdec(4) bfmt(f) tdec(2) tfmt(f) rdec(3
> ) rfmt(f) word replace
Tab12_B.rtf
dir : seeout

. 
. * 2000-2006
. regress riskprem_b chargeoff chargeofftrend i.year if pre==1, vce(cluster year
> )

Linear regression                               Number of obs     =      3,626
                                                F(1, 6)           =          .
                                                Prob > F          =          .
                                                R-squared         =     0.0652
                                                Root MSE          =     .52541

                                    (Std. err. adjusted for 7 clusters in year)
-------------------------------------------------------------------------------
              |               Robust
   riskprem_b | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
--------------+----------------------------------------------------------------
    chargeoff |  -.0552326   .0396616    -1.39   0.213     -.152281    .0418158
chargeofftr~d |  -.0936695   .0211399    -4.43   0.004    -.1453969   -.0419421
              |
         year |
        2001  |   .1318401   .0119505    11.03   0.000     .1025983    .1610818
        2002  |   .0752518   .0103982     7.24   0.000     .0498083    .1006953
        2003  |   .0253085   .0015541    16.28   0.000     .0215056    .0291113
        2004  |   .0112436    .018535     0.61   0.566      -.03411    .0565972
        2005  |  -.2165027   .0312639    -6.93   0.000    -.2930027   -.1400027
        2006  |   -.273464   .1117177    -2.45   0.050    -.5468273   -.0001007
              |
        _cons |   .8911676    .246166     3.62   0.011      .288821    1.493514
-------------------------------------------------------------------------------

. outreg2 using Tab12_B, stats(coef tstat) noaster adjr2 nocons title("B Tranche
> ") ctitle("2000-2006") drop(i.year riskprem*) bdec(4) bfmt(f) tdec(2) tfmt(f) 
> rdec(3) rfmt(f) word
Tab12_B.rtf
dir : seeout

. 
. * 2007-2009
. regress riskprem_b chargeoff chargeofftrend i.year if cri==1, vce(cluster year
> )

Linear regression                               Number of obs     =      2,528
                                                F(1, 2)           =          .
                                                Prob > F          =          .
                                                R-squared         =     0.4752
                                                Root MSE          =     3.7771

                                    (Std. err. adjusted for 3 clusters in year)
-------------------------------------------------------------------------------
              |               Robust
   riskprem_b | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
--------------+----------------------------------------------------------------
    chargeoff |   -.300113   .8748287    -0.34   0.764    -4.064197    3.463971
chargeofftr~d |   4.491521   1.100484     4.08   0.055    -.2434776     9.22652
              |
         year |
        2008  |   4.848131   1.444439     3.36   0.078    -1.366791    11.06305
        2009  |   8.711049   4.817301     1.81   0.212    -12.01612    29.43822
              |
        _cons |   1.636389   3.258003     0.50   0.665    -12.38167    15.65445
-------------------------------------------------------------------------------

. outreg2 using Tab12_B, stats(coef tstat) noaster adjr2 nocons title("B Tranche
> ") ctitle("2007-2009") drop(i.year riskprem*) bdec(4) bfmt(f) tdec(2) tfmt(f) 
> rdec(3) rfmt(f) word
Tab12_B.rtf
dir : seeout

. 
. * 2010-2020
. regress riskprem_b chargeoff chargeofftrend i.year if post==1, vce(cluster yea
> r)

Linear regression                               Number of obs     =      2,012
                                                F(1, 9)           =          .
                                                Prob > F          =          .
                                                R-squared         =     0.1279
                                                Root MSE          =     .70592

                                   (Std. err. adjusted for 10 clusters in year)
-------------------------------------------------------------------------------
              |               Robust
   riskprem_b | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
--------------+----------------------------------------------------------------
    chargeoff |    .005673   .0247247     0.23   0.824    -.0502581    .0616041
chargeofftr~d |  -.0008128   .0340118    -0.02   0.981    -.0777529    .0761274
              |
         year |
        2011  |   .0414858    .086227     0.48   0.642    -.1535732    .2365448
        2012  |   .2362929   .1403489     1.68   0.127    -.0811984    .5537842
        2013  |  -.1730471   .1483122    -1.17   0.273    -.5085527    .1624585
        2014  |  -.4252149   .1525037    -2.79   0.021    -.7702023   -.0802276
        2015  |  -.3832531    .157497    -2.43   0.038     -.739536   -.0269702
        2017  |  -.4931025   .1369827    -3.60   0.006    -.8029789   -.1832261
        2018  |  -.5108427   .1464721    -3.49   0.007    -.8421856   -.1794997
        2019  |  -.5497919   .1267116    -4.34   0.002    -.8364335   -.2631503
        2020  |    -.59523   .0127352   -46.74   0.000     -.624039   -.5664211
              |
        _cons |   1.148283   .2150771     5.34   0.000     .6617446    1.634821
-------------------------------------------------------------------------------

. outreg2 using Tab12_B, stats(coef tstat) noaster adjr2 nocons title("B Tranche
> ") ctitle("2010-2020") drop(i.year riskprem*) bdec(4) bfmt(f) tdec(2) tfmt(f) 
> rdec(3) rfmt(f) word
Tab12_B.rtf
dir : seeout

. 
. 
. *******************
. * C Tranche
. * All
. regress riskprem_c chargeoff chargeofftrend i.year, vce(cluster year)

Linear regression                               Number of obs     =      8,166
                                                F(1, 19)          =          .
                                                Prob > F          =          .
                                                R-squared         =     0.5513
                                                Root MSE          =     3.5554

                                   (Std. err. adjusted for 20 clusters in year)
-------------------------------------------------------------------------------
              |               Robust
   riskprem_c | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
--------------+----------------------------------------------------------------
    chargeoff |  -.0841153   .3124159    -0.27   0.791    -.7380093    .5697786
chargeofftr~d |   1.027019   1.134405     0.91   0.377    -1.347317    3.401356
              |
         year |
        2001  |   .0595636   .0807722     0.74   0.470    -.1094945    .2286217
        2002  |   .1266427   .0631902     2.00   0.060    -.0056159    .2589013
        2003  |   .1668846   .0405381     4.12   0.001     .0820374    .2517318
        2004  |   .0627743    .121558     0.52   0.612    -.1916495     .317198
        2005  |  -.5614846   .2976613    -1.89   0.075    -1.184497    .0615276
        2006  |  -.4051738   .8262017    -0.49   0.629    -2.134434    1.324086
        2007  |  -.0005837   .8286756    -0.00   0.999    -1.735022    1.733854
        2008  |   7.333742   .4427944    16.56   0.000     6.406963    8.260521
        2009  |   12.06834   .8589435    14.05   0.000     10.27055    13.86613
        2010  |   1.571591   .8516403     1.85   0.081    -.2109129    3.354094
        2011  |   1.178797    .268601     4.39   0.000     .6166087    1.740986
        2012  |   1.276402   .9996524     1.28   0.217    -.8158944    3.368699
        2013  |   .5331897   1.103603     0.48   0.635    -1.776679    2.843058
        2014  |    .383684   1.050323     0.37   0.719    -1.814667    2.582035
        2015  |   .2002229   1.244414     0.16   0.874    -2.404365    2.804811
        2017  |   .3661865   .9764545     0.38   0.712    -1.677556    2.409929
        2018  |    .335647   1.069299     0.31   0.757    -1.902423    2.573717
        2019  |   .2432148   .8672846     0.28   0.782    -1.572033    2.058462
        2020  |   .5399778   .7616365     0.71   0.487    -1.054146    2.134101
              |
        _cons |   1.420431   1.955582     0.73   0.476     -2.67265    5.513512
-------------------------------------------------------------------------------

. outreg2 using Tab12_C, stats(coef tstat) noaster adjr2 nocons title("C Tranche
> ") ctitle("All") drop(i.year riskprem*) bdec(4) bfmt(f) tdec(2) tfmt(f) rdec(3
> ) rfmt(f) word replace
Tab12_C.rtf
dir : seeout

. 
. * 2000-2006
. regress riskprem_c chargeoff chargeofftrend i.year if pre==1, vce(cluster year
> )

Linear regression                               Number of obs     =      3,626
                                                F(1, 6)           =          .
                                                Prob > F          =          .
                                                R-squared         =     0.0676
                                                Root MSE          =     .98597

                                    (Std. err. adjusted for 7 clusters in year)
-------------------------------------------------------------------------------
              |               Robust
   riskprem_c | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
--------------+----------------------------------------------------------------
    chargeoff |  -.0294529    .069564    -0.42   0.687    -.1996698     .140764
chargeofftr~d |  -.2053774   .0428437    -4.79   0.003    -.3102121   -.1005428
              |
         year |
        2001  |   .1549921   .0231584     6.69   0.001     .0983255    .2116586
        2002  |   .1645797   .0192216     8.56   0.000     .1175462    .2116132
        2003  |   .1279335   .0023581    54.25   0.000     .1221636    .1337035
        2004  |   .0348107   .0334924     1.04   0.339    -.0471422    .1167636
        2005  |  -.4350056   .0534124    -8.14   0.000    -.5657011   -.3043102
        2006  |  -.3530866   .1977727    -1.79   0.124    -.8370189    .1308457
              |
        _cons |   1.051563   .4312365     2.44   0.051    -.0036346    2.106761
-------------------------------------------------------------------------------

. outreg2 using Tab12_C, stats(coef tstat) noaster  adjr2 nocons title("C Tranch
> e") ctitle("2000-2006") drop(i.year riskprem*) bdec(4) bfmt(f) tdec(2) tfmt(f)
>  rdec(3) rfmt(f) word
Tab12_C.rtf
dir : seeout

. 
. * 2007-2009
. regress riskprem_c chargeoff chargeofftrend i.year if cri==1, vce(cluster year
> )

Linear regression                               Number of obs     =      2,528
                                                F(1, 2)           =          .
                                                Prob > F          =          .
                                                R-squared         =     0.4874
                                                Root MSE          =     5.6659

                                    (Std. err. adjusted for 3 clusters in year)
-------------------------------------------------------------------------------
              |               Robust
   riskprem_c | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
--------------+----------------------------------------------------------------
    chargeoff |  -.4425481   1.312608    -0.34   0.768    -6.090243    5.205147
chargeofftr~d |   6.920121    1.66595     4.15   0.053    -.2478819    14.08812
              |
         year |
        2008  |   6.993966   2.168398     3.23   0.084    -2.335898    16.32383
        2009  |    13.4005   7.228523     1.85   0.205    -17.70133    44.50232
              |
        _cons |   2.358993   4.888707     0.48   0.677    -18.67541     23.3934
-------------------------------------------------------------------------------

. outreg2 using Tab12_C, stats(coef tstat) noaster adjr2 nocons title("C Tranche
> ") ctitle("2007-2009") drop(i.year riskprem*) bdec(4) bfmt(f) tdec(2) tfmt(f) 
> rdec(3) rfmt(f) word
Tab12_C.rtf
dir : seeout

. 
. * 2010-2020
. regress riskprem_c chargeoff chargeofftrend i.year if post==1, vce(cluster yea
> r)

Linear regression                               Number of obs     =      2,012
                                                F(1, 9)           =          .
                                                Prob > F          =          .
                                                R-squared         =     0.0842
                                                Root MSE          =     1.1519

                                   (Std. err. adjusted for 10 clusters in year)
-------------------------------------------------------------------------------
              |               Robust
   riskprem_c | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
--------------+----------------------------------------------------------------
    chargeoff |   .0087394   .0484811     0.18   0.861    -.1009325    .1184114
chargeofftr~d |  -.0707796   .0474244    -1.49   0.170    -.1780609    .0365018
              |
         year |
        2011  |  -.1195438    .170008    -0.70   0.500    -.5041287    .2650411
        2012  |   .3750215   .2725177     1.38   0.202    -.2414564    .9914993
        2013  |  -.3315563   .2880066    -1.15   0.279    -.9830725      .31996
        2014  |  -.7175658   .3009176    -2.38   0.041    -1.398289    -.036843
        2015  |  -.5809907   .3050861    -1.90   0.089    -1.271143    .1091619
        2017  |   -.509185   .2651803    -1.92   0.087    -1.109064    .0906945
        2018  |  -.5587135   .2848281    -1.96   0.081    -1.203039    .0856124
        2019  |  -.6317395   .2442871    -2.59   0.029    -1.184355   -.0791236
        2020  |  -.6309226   .0278292   -22.67   0.000    -.6938766   -.5679685
              |
        _cons |   2.017852   .4186194     4.82   0.001     1.070869    2.964835
-------------------------------------------------------------------------------

. outreg2 using Tab12_C, stats(coef tstat) noaster  adjr2 nocons title("C Tranch
> e") ctitle("2010-2020") drop(i.year riskprem*) bdec(4) bfmt(f) tdec(2) tfmt(f)
>  rdec(3) rfmt(f) word
Tab12_C.rtf
dir : seeout

. 
. log close
      name:  <unnamed>
       log:  D:\Dropbox\Work\Research\CreditCardABSRewrite\Draft\ReplicationFile
> s\Tab_12\Table_12_Log.log
  log type:  text
 closed on:   1 Jan 2022, 16:12:10
--------------------------------------------------------------------------------
